const cartSQL = {
    queryAll:'select * FROM cart',
    updateCart:'update cart set is_select=? where user_id=? and goods_id=?',
    queryGoodsId:'select goods_id,is_select from cart where user_id=?',
    deleteCart:'delete from cart where user_id=? and goods_id=?',
    insert: 'insert into cart(user_id,goods_id,is_select,is_collect) values(?,?,?,?)',  // 插入新用户
    SelectAll:'update cart set is_select=? where user_id=?',
    deleteSelect:'delete from cart where user_id=? and is_select=1'
}

module.exports = cartSQL
